﻿CREATE PROCEDURE TopPages 

AS
BEGIN
	select WebApplication.DisplayName, SlowestPages.URL, SlowestPages.MaximumDuraion, SlowestPages.AverageDuration, SlowestPages.MinimumDuration, SlowestPages.MaximumDatabseQueries, SlowestPages.AverageDatabaseQueries, SlowestPages.MinimumDatabaseQueries, SlowestPages.NumberRequests
	from WebApplication, SlowestPages
	where WebApplication.WebApplicationID = SlowestPages.WebApplicationID
END